﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'PRC_TB_ALERTS_UP')
	BEGIN
		DROP  Procedure  dbo.PRC_TB_ALERTS_UP
	END

GO

CREATE Procedure dbo.PRC_TB_ALERTS_UP
	(
		@TA_ID int,
		@TA_NAME varchar(250),
		@TA_STATE int,
		@TA_SLEEP_DATE datetime,
		@TA_TYPE int
	)

AS

update TB_ALERTS
set 
	TA_NAME = @TA_NAME,
	TA_STATE = @TA_STATE,
	TA_SLEEP_DATE = @TA_SLEEP_DATE,
	TA_TYPE = @TA_TYPE
where TA_ID = @TA_ID

GO

GRANT EXEC ON dbo.PRC_TB_ALERTS_UP TO PUBLIC

GO

